Word | Frequency | Number of right neighbors | Number of left neighbors | Ratio |
---|---|---|---|---|
وی | 601 | 20 | 1 | 20.0000 |
مطرح | 92 | 8 | 1 | 8.0000 |
فراهم | 48 | 8 | 1 | 8.0000 |
تبدیل | 75 | 7 | 1 | 7.0000 |
دست | 293 | 19 | 3 | 6.3333 |
بیشتری | 64 | 6 | 1 | 6.0000 |
ارائه | 131 | 12 | 2 | 6.0000 |
حضرت | 38 | 6 | 1 | 6.0000 |
فعالیت | 94 | 6 | 1 | 6.0000 |
دیده | 53 | 6 | 1 | 6.0000 |
صحبت | 63 | 6 | 1 | 6.0000 |
طبق | 75 | 6 | 1 | 6.0000 |
نماینده | 91 | 6 | 1 | 6.0000 |
مدیرکل | 62 | 12 | 2 | 6.0000 |
چهار | 65 | 6 | 1 | 6.0000 |
وزارت | 120 | 17 | 3 | 5.6667 |
امام | 125 | 11 | 2 | 5.5000 |
وارد | 141 | 10 | 2 | 5.0000 |
شکل | 70 | 5 | 1 | 5.0000 |
منتقل | 34 | 5 | 1 | 5.0000 |
Word | Frequency | Number of right neighbors | Number of left neighbors | Ratio |
---|---|---|---|---|
گفت | 721 | 3 | 45 | 0.0667 |
است | 3253 | 10 | 116 | 0.0862 |
اخیر | 110 | 1 | 11 | 0.0909 |
شد | 908 | 7 | 68 | 0.1029 |
نوشت | 83 | 1 | 8 | 0.1250 |
کرد | 1139 | 8 | 55 | 0.1455 |
افزود | 269 | 1 | 6 | 0.1667 |
محیط | 47 | 1 | 6 | 0.1667 |
شده | 967 | 14 | 80 | 0.1750 |
شود | 563 | 7 | 37 | 0.1892 |
مدیران | 55 | 1 | 5 | 0.2000 |
والیبال | 21 | 1 | 5 | 0.2000 |
نسبت | 113 | 1 | 5 | 0.2000 |
مختلف | 115 | 1 | 5 | 0.2000 |
بود | 839 | 7 | 35 | 0.2000 |
کردن | 120 | 1 | 5 | 0.2000 |
امید | 58 | 1 | 5 | 0.2000 |
این است | 102 | 1 | 5 | 0.2000 |
فصل | 71 | 1 | 5 | 0.2000 |
مدت | 55 | 1 | 5 | 0.2000 |
In this subsection, we compute the ratio of the number of right neighbors and the number of left neighbors. Again, we look for words with extreme ratios:
Data for first table:
select word,w.freq,aa.cnt, bb.cnt,aa.cnt/bb.cnt as r from words w, (select w1_id,count(c.w2_id) as cnt from co_n c where w1_id>100 group by w1_id) aa, (select w2_id,count(c.w1_id) as cnt from co_n c where w2_id>100 group by w2_id) bb where w_id=aa.w1_id and aa.w1_id=bb.w2_id order by r desc limit 20;
Diagram data:
select aa.cnt, bb.cnt from (select w1_id,count(c.w2_id) as cnt from co_n c where w1_id>100 group by w1_id) aa, (select w2_id,count(c.w1_id) as cnt from co_n c where w2_id>100 group by w2_id) bb where aa.w1_id=bb.w2_id;
5.1.7.1 Number of NN co-occurrences vs. Frequency I
5.1.7.2 Number of NN co-occurrences vs. Frequency II